<!DOCTYPE HTML>
<html lang="en" >
    
    <head>
        
        <meta charset="UTF-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge" />
        <title>数据访问层 | 新浪微博开发笔记</title>
        <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
        <meta name="description" content="">
        <meta name="generator" content="GitBook 2.1.0">
        
        
        <meta name="HandheldFriendly" content="true"/>
        <meta name="viewport" content="width=device-width, initial-scale=1, user-scalable=no">
        <meta name="apple-mobile-web-app-capable" content="yes">
        <meta name="apple-mobile-web-app-status-bar-style" content="black">
        <link rel="apple-touch-icon-precomposed" sizes="152x152" href="../gitbook/images/apple-touch-icon-precomposed-152.png">
        <link rel="shortcut icon" href="../gitbook/images/favicon.ico" type="image/x-icon">
        
    <link rel="stylesheet" href="../gitbook/style.css">
    
    

        
    
    
    <link rel="next" href="../sqlite/clean cache.html" />
    
    
    <link rel="prev" href="../sqlite/data model.html" />
    

        
    </head>
    <body>
        
        
    <div class="book" data-level="0.12.2" data-basepath=".." data-revision="Wed Oct 14 2015 07:05:46 GMT+0800 (CST)">
    

<div class="book-summary">
    <div class="book-search">
        <input type="text" placeholder="Type to search" class="form-control" />
    </div>
    <ul class="summary">
        
        
        
        

        

        
    
        <li class="chapter " data-level="0" data-path="index.html">
            
                
                    <a href="../index.html">
                        <i class="fa fa-check"></i>
                        
                        新浪微博笔记
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.1" data-path="project init/prepare project.html">
            
                
                    <a href="../project init/prepare project.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.1.</b>
                        
                        准备工作
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.1.1" data-path="project init/project deploy.html">
            
                
                    <a href="../project init/project deploy.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.1.1.</b>
                        
                        项目部署
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.1.2" data-path="project init/project settings.html">
            
                
                    <a href="../project init/project settings.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.1.2.</b>
                        
                        项目设置
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.1.3" data-path="project init/confirm architecture.html">
            
                
                    <a href="../project init/confirm architecture.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.1.3.</b>
                        
                        架构确定
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.1.4" data-path="project init/mvvm.html">
            
                
                    <a href="../project init/mvvm.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.1.4.</b>
                        
                        MVVM
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.2" data-path="create project/readme.html">
            
                
                    <a href="../create project/readme.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.2.</b>
                        
                        项目搭建
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.2.1" data-path="create project/create files.html">
            
                
                    <a href="../create project/create files.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.2.1.</b>
                        
                        创建文件
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.2.2" data-path="create project/add child controllers.html">
            
                
                    <a href="../create project/add child controllers.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.2.2.</b>
                        
                        添加子控制器
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.2.3" data-path="create project/custom main tabbar.html">
            
                
                    <a href="../create project/custom main tabbar.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.2.3.</b>
                        
                        自定义 TabBar
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.2.4" data-path="create project/summary.html">
            
                
                    <a href="../create project/summary.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.2.4.</b>
                        
                        阶段性小结
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.3" data-path="visitor/readme.html">
            
                
                    <a href="../visitor/readme.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.3.</b>
                        
                        访客视图
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.3.1" data-path="visitor/base table view controller.html">
            
                
                    <a href="../visitor/base table view controller.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.3.1.</b>
                        
                        表格视图控制器基类
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.3.2" data-path="visitor/visitor login view.html">
            
                
                    <a href="../visitor/visitor login view.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.3.2.</b>
                        
                        用户登录视图
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.3.3" data-path="visitor/setup login info.html">
            
                
                    <a href="../visitor/setup login info.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.3.3.</b>
                        
                        设置未登录信息
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.3.4" data-path="visitor/home animation.html">
            
                
                    <a href="../visitor/home animation.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.3.4.</b>
                        
                        首页动画
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.3.5" data-path="visitor/login buttons delegate.html">
            
                
                    <a href="../visitor/login buttons delegate.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.3.5.</b>
                        
                        登录&amp;注册代理回调
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.3.6" data-path="visitor/appearance.html">
            
                
                    <a href="../visitor/appearance.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.3.6.</b>
                        
                        导航栏全局外观
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.4" data-path="frameworks/readme.html">
            
                
                    <a href="../frameworks/readme.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.4.</b>
                        
                        第三方框架
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.4.1" data-path="frameworks/afnetworking.html">
            
                
                    <a href="../frameworks/afnetworking.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.4.1.</b>
                        
                        AFNetworking
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.4.2" data-path="frameworks/svprogresshud sdwebimage.html">
            
                
                    <a href="../frameworks/svprogresshud sdwebimage.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.4.2.</b>
                        
                        SVProgressHUD 和 SDWebImage
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.4.3" data-path="frameworks/snapkit.html">
            
                
                    <a href="../frameworks/snapkit.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.4.3.</b>
                        
                        SnapKit
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.5" data-path="oauth/readme.html">
            
                
                    <a href="../oauth/readme.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.5.</b>
                        
                        OAuth
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.5.1" data-path="oauth/register app.html">
            
                
                    <a href="../oauth/register app.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.5.1.</b>
                        
                        注册应用程序
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.5.2" data-path="oauth/load oauth page.html">
            
                
                    <a href="../oauth/load oauth page.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.5.2.</b>
                        
                        加载授权页面
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.6" data-path="access token/readme.html">
            
                
                    <a href="../access token/readme.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.6.</b>
                        
                        Access Token
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.6.1" data-path="access token/load access token.html">
            
                
                    <a href="../access token/load access token.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.6.1.</b>
                        
                        加载 AccessToken
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.6.2" data-path="access token/user account.html">
            
                
                    <a href="../access token/user account.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.6.2.</b>
                        
                        用户账户模型
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.6.3" data-path="access token/expires date.html">
            
                
                    <a href="../access token/expires date.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.6.3.</b>
                        
                        过期日期
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.6.4" data-path="access token/load user info.html">
            
                
                    <a href="../access token/load user info.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.6.4.</b>
                        
                        加载用户信息
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.6.5" data-path="access token/archive user account.html">
            
                
                    <a href="../access token/archive user account.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.6.5.</b>
                        
                        归档 &amp; 解档
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.6.6" data-path="access token/view model.html">
            
                
                    <a href="../access token/view model.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.6.6.</b>
                        
                        视图模型
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.6.7" data-path="access token/error enum.html">
            
                
                    <a href="../access token/error enum.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.6.7.</b>
                        
                        自定义错误枚举
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.7" data-path="newfeature/index.html">
            
                
                    <a href="../newfeature/index.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.7.</b>
                        
                        新特性和欢迎界面
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.7.1" data-path="newfeature/newfeature.html">
            
                
                    <a href="../newfeature/newfeature.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.7.1.</b>
                        
                        新特性
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.7.2" data-path="newfeature/welcome.html">
            
                
                    <a href="../newfeature/welcome.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.7.2.</b>
                        
                        欢迎界面
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.7.3" data-path="newfeature/switch vc.html">
            
                
                    <a href="../newfeature/switch vc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.7.3.</b>
                        
                        切换界面
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.8" data-path="homepage/index.html">
            
                
                    <a href="../homepage/index.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.</b>
                        
                        首页布局
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.8.1" data-path="homepage/status model.html">
            
                
                    <a href="../homepage/status model.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.1.</b>
                        
                        微博数据模型
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.8.2" data-path="homepage/tableview show data.html">
            
                
                    <a href="../homepage/tableview show data.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.2.</b>
                        
                        显示表格数据
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.8.3" data-path="homepage/user model.html">
            
                
                    <a href="../homepage/user model.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.3.</b>
                        
                        用户模型
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.8.4" data-path="homepage/status view model.html">
            
                
                    <a href="../homepage/status view model.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.4.</b>
                        
                        微博视图模型
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.8.5" data-path="homepage/custom cell.html">
            
                
                    <a href="../homepage/custom cell.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.5.</b>
                        
                        自定义 Cell
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.8.6" data-path="homepage/prepare for pictureview.html">
            
                
                    <a href="../homepage/prepare for pictureview.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.6.</b>
                        
                        配图视图准备
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.8.7" data-path="homepage/picture view.html">
            
                
                    <a href="../homepage/picture view.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.7.</b>
                        
                        配图视图
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.8.8" data-path="homepage/retweeted_status.html">
            
                
                    <a href="../homepage/retweeted_status.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.8.</b>
                        
                        转发微博
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.8.9" data-path="homepage/single picture.html">
            
                
                    <a href="../homepage/single picture.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.8.9.</b>
                        
                        单张图片比例
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.9" data-path="refresh/index.html">
            
                
                    <a href="../refresh/index.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.9.</b>
                        
                        刷新
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.9.1" data-path="refresh/pullup view.html">
            
                
                    <a href="../refresh/pullup view.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.9.1.</b>
                        
                        上拉刷新控件
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.9.2" data-path="refresh/refresh data.html">
            
                
                    <a href="../refresh/refresh data.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.9.2.</b>
                        
                        刷新数据
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.9.3" data-path="refresh/pulldown tips.html">
            
                
                    <a href="../refresh/pulldown tips.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.9.3.</b>
                        
                        下拉刷新提示
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.10" data-path="compose/index.html">
            
                
                    <a href="../compose/index.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.10.</b>
                        
                        发布微博
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.10.1" data-path="compose/setup ui.html">
            
                
                    <a href="../compose/setup ui.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.10.1.</b>
                        
                        搭建界面
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.10.2" data-path="compose/select picture.html">
            
                
                    <a href="../compose/select picture.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.10.2.</b>
                        
                        选择照片
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.10.3" data-path="compose/post status.html">
            
                
                    <a href="../compose/post status.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.10.3.</b>
                        
                        发布微博
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.11" data-path="emoticon/index.html">
            
                
                    <a href="../emoticon/index.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.11.</b>
                        
                        表情键盘
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.11.1" data-path="emoticon/prepare ui.html">
            
                
                    <a href="../emoticon/prepare ui.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.11.1.</b>
                        
                        准备界面
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.11.2" data-path="emoticon/load bundle data.html">
            
                
                    <a href="../emoticon/load bundle data.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.11.2.</b>
                        
                        加载模型数据
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.11.3" data-path="emoticon/show emoticon.html">
            
                
                    <a href="../emoticon/show emoticon.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.11.3.</b>
                        
                        显示表情符号
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.11.4" data-path="emoticon/upgrade model.html">
            
                
                    <a href="../emoticon/upgrade model.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.11.4.</b>
                        
                        提升数据模型
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.11.5" data-path="emoticon/selected emoticon.html">
            
                
                    <a href="../emoticon/selected emoticon.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.11.5.</b>
                        
                        选中表情事件
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.11.6" data-path="emoticon/attribute text.html">
            
                
                    <a href="../emoticon/attribute text.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.11.6.</b>
                        
                        属性文本
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.11.7" data-path="emoticon/merge_emoticon.html">
            
                
                    <a href="../emoticon/merge_emoticon.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.11.7.</b>
                        
                        整合到新浪微博
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.11.8" data-path="emoticon/favorite emoticon.html">
            
                
                    <a href="../emoticon/favorite emoticon.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.11.8.</b>
                        
                        内存表情排序
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.12" data-path="sqlite/index.html">
            
                
                    <a href="../sqlite/index.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.12.</b>
                        
                        数据缓存
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.12.1" data-path="sqlite/data model.html">
            
                
                    <a href="../sqlite/data model.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.12.1.</b>
                        
                        数据模型设计
                    </a>
                
            
            
        </li>
    
        <li class="chapter active" data-level="0.12.2" data-path="sqlite/statusdal.html">
            
                
                    <a href="../sqlite/statusdal.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.12.2.</b>
                        
                        数据访问层
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.12.3" data-path="sqlite/clean cache.html">
            
                
                    <a href="../sqlite/clean cache.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.12.3.</b>
                        
                        清理数据缓存
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.13" data-path="ending/index.html">
            
                
                    <a href="../ending/index.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.13.</b>
                        
                        微博收尾
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.13.1" data-path="ending/status create at.html">
            
                
                    <a href="../ending/status create at.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.13.1.</b>
                        
                        微博时间
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.13.2" data-path="ending/regex.html">
            
                
                    <a href="../ending/regex.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.13.2.</b>
                        
                        正则表达式
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.13.3" data-path="ending/emoticon string.html">
            
                
                    <a href="../ending/emoticon string.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.13.3.</b>
                        
                        表情字符串
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.13.4" data-path="ending/fflabel.html">
            
                
                    <a href="../ending/fflabel.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.13.4.</b>
                        
                        FFLabel
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.13.5" data-path="ending/textkit.html">
            
                
                    <a href="../ending/textkit.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.13.5.</b>
                        
                        TextKit
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    
        <li class="chapter " data-level="0.14" data-path="appendix/readme.html">
            
                
                    <a href="../appendix/readme.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.14.</b>
                        
                        附录
                    </a>
                
            
            
            <ul class="articles">
                
    
        <li class="chapter " data-level="0.14.1" data-path="appendix/image assets.html">
            
                
                    <a href="../appendix/image assets.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.14.1.</b>
                        
                        图片素材
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.14.2" data-path="appendix/cocoa pod.html">
            
                
                    <a href="../appendix/cocoa pod.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.14.2.</b>
                        
                        cocoa pod
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.14.3" data-path="appendix/singleton.html">
            
                
                    <a href="../appendix/singleton.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.14.3.</b>
                        
                        单例
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.14.4" data-path="appendix/swift_vs_oc.html">
            
                
                    <a href="../appendix/swift_vs_oc.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.14.4.</b>
                        
                        为什么要学习 Swift
                    </a>
                
            
            
        </li>
    
        <li class="chapter " data-level="0.14.5" data-path="appendix/emoji.html">
            
                
                    <a href="../appendix/emoji.html">
                        <i class="fa fa-check"></i>
                        
                            <b>0.14.5.</b>
                        
                        emoji
                    </a>
                
            
            
        </li>
    

            </ul>
            
        </li>
    

            </ul>
            
        </li>
    


        
        <li class="divider"></li>
        <li>
            <a href="https://www.gitbook.com" target="blank" class="gitbook-link">
                Published with GitBook
            </a>
        </li>
        
    </ul>
</div>

    <div class="book-body">
        <div class="body-inner">
            <div class="book-header">
    <!-- Actions Left -->
    <a href="#" class="btn pull-left toggle-summary" aria-label="Table of Contents"><i class="fa fa-align-justify"></i></a>
    <a href="#" class="btn pull-left toggle-search" aria-label="Search"><i class="fa fa-search"></i></a>
    
    <div id="font-settings-wrapper" class="dropdown pull-left">
        <a href="#" class="btn toggle-dropdown" aria-label="Font Settings"><i class="fa fa-font"></i>
        </a>
        <div class="dropdown-menu font-settings">
    <div class="dropdown-caret">
        <span class="caret-outer"></span>
        <span class="caret-inner"></span>
    </div>

    <div class="buttons">
        <button type="button" id="reduce-font-size" class="button size-2">A</button>
        <button type="button" id="enlarge-font-size" class="button size-2">A</button>
    </div>

    <div class="buttons font-family-list">
        <button type="button" data-font="0" class="button">Serif</button>
        <button type="button" data-font="1" class="button">Sans</button>
    </div>

    <div class="buttons color-theme-list">
        <button type="button" id="color-theme-preview-0" class="button size-3" data-theme="0">White</button>
        <button type="button" id="color-theme-preview-1" class="button size-3" data-theme="1">Sepia</button>
        <button type="button" id="color-theme-preview-2" class="button size-3" data-theme="2">Night</button>
    </div>
</div>

    </div>

    <!-- Actions Right -->
    
    <div class="dropdown pull-right">
        <a href="#" class="btn toggle-dropdown" aria-label="Share"><i class="fa fa-share-alt"></i>
        </a>
        <div class="dropdown-menu font-settings dropdown-left">
            <div class="dropdown-caret">
                <span class="caret-outer"></span>
                <span class="caret-inner"></span>
            </div>
            <div class="buttons">
                <button type="button" data-sharing="twitter" class="button">
                    Share on Twitter
                </button>
                <button type="button" data-sharing="google-plus" class="button">
                    Share on Google
                </button>
                <button type="button" data-sharing="facebook" class="button">
                    Share on Facebook
                </button>
                <button type="button" data-sharing="weibo" class="button">
                    Share on Weibo
                </button>
                <button type="button" data-sharing="instapaper" class="button">
                    Share on Instapaper
                </button>
            </div>
        </div>
    </div>
    

    
    <a href="#" target="_blank" class="btn pull-right google-plus-sharing-link sharing-link" data-sharing="google-plus" aria-label="Google"><i class="fa fa-google-plus"></i></a>
    
    
    <a href="#" target="_blank" class="btn pull-right facebook-sharing-link sharing-link" data-sharing="facebook" aria-label="Facebook"><i class="fa fa-facebook"></i></a>
    
    
    <a href="#" target="_blank" class="btn pull-right twitter-sharing-link sharing-link" data-sharing="twitter" aria-label="Twitter"><i class="fa fa-twitter"></i></a>
    
    
    


    <!-- Title -->
    <h1>
        <i class="fa fa-circle-o-notch fa-spin"></i>
        <a href="../" >新浪微博开发笔记</a>
    </h1>
</div>

            <div class="page-wrapper" tabindex="-1">
                <div class="page-inner">
                
                
                    <section class="normal" id="section-">
                    
                        <h1 id="%E6%95%B0%E6%8D%AE%E8%AE%BF%E9%97%AE%E5%B1%82">&#x6570;&#x636E;&#x8BBF;&#x95EE;&#x5C42;</h1>
<h2 id="%E6%95%B0%E6%8D%AE%E8%AE%BF%E9%97%AE%E5%B1%82%E6%A8%A1%E5%9E%8B%E8%AE%BE%E8%AE%A1">&#x6570;&#x636E;&#x8BBF;&#x95EE;&#x5C42;&#x6A21;&#x578B;&#x8BBE;&#x8BA1;</h2>
<p><img src="StatusDAL.png" alt=""></p>
<h2 id="%E6%95%B0%E6%8D%AE%E8%AE%BF%E9%97%AE%E5%B1%82%E5%AF%B9%E8%B1%A1%E5%AE%9E%E7%8E%B0%E6%95%B0%E6%8D%AE%E7%BC%93%E5%AD%98">&#x6570;&#x636E;&#x8BBF;&#x95EE;&#x5C42;&#x5BF9;&#x8C61;&#x5B9E;&#x73B0;&#x6570;&#x636E;&#x7F13;&#x5B58;</h2>
<ul>
<li>&#x65B0;&#x5EFA; <code>StatusDAL</code> &#x4E13;&#x95E8;&#x8D1F;&#x8D23;&#x5FAE;&#x535A;&#x6570;&#x636E;&#x7684;&#x6570;&#x636E;&#x7F13;&#x5B58;&#x548C;&#x7F51;&#x7EDC;&#x6570;&#x636E;&#x7684;&#x5904;&#x7406;</li>
<li>&#x65B0;&#x5EFA; <code>loadStatus</code> &#x51FD;&#x6570;&#xFF0C;&#x7F16;&#x5199;&#x4F2A;&#x4EE3;&#x7801;</li>
</ul>
<pre><code class="lang-swift">/// &#x5FAE;&#x535A;&#x6570;&#x636E;&#x6570;&#x636E;&#x8BBF;&#x95EE;&#x5C42;
class StatusDAL {

    /// &#x52A0;&#x8F7D;&#x5FAE;&#x535A;&#x6570;&#x636E;
    class func loadStatus() -&gt; [Status]? {

        // 1. &#x68C0;&#x67E5;&#x672C;&#x5730;&#x662F;&#x5426;&#x5B58;&#x5728;&#x7F13;&#x5B58;&#x6570;&#x636E;
        // 2. &#x5982;&#x679C;&#x6709;&#x8FD4;&#x56DE;&#x672C;&#x5730;&#x7F13;&#x5B58;&#x6570;&#x636E;
        // 3. &#x5982;&#x679C;&#x6CA1;&#x6709;&#x53D1;&#x8D77;&#x7F51;&#x7EDC;&#x8BF7;&#x6C42;
        // 4. &#x52A0;&#x8F7D;&#x5B8C;&#x6210;&#x4FDD;&#x5B58;&#x81F3;&#x6570;&#x636E;&#x5E93;
        return nil
    }
}
</code></pre>
<h3 id="%E5%B0%86%E7%BD%91%E7%BB%9C%E6%95%B0%E6%8D%AE%E4%BF%9D%E5%AD%98%E8%87%B3%E6%95%B0%E6%8D%AE%E5%BA%93">&#x5C06;&#x7F51;&#x7EDC;&#x6570;&#x636E;&#x4FDD;&#x5B58;&#x81F3;&#x6570;&#x636E;&#x5E93;</h3>
<ul>
<li>&#x65B0;&#x5EFA; <code>saveStatus</code> &#x51FD;&#x6570;&#xFF0C;&#x9996;&#x5148;&#x89E3;&#x51B3;&#x4FDD;&#x5B58;&#x5FAE;&#x535A;&#x6570;&#x636E;&#x95EE;&#x9898;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">/// &#x5C06;&#x7F51;&#x7EDC;&#x8FD4;&#x56DE;&#x7684;&#x6570;&#x636E;&#x5B57;&#x5178;&#x6570;&#x7EC4;&#x4FDD;&#x5B58;&#x81F3;&#x6570;&#x636E;&#x5E93;</span>
<span class="hljs-comment">///</span>
<span class="hljs-comment">/// - parameter array: &#x7F51;&#x7EDC;&#x8FD4;&#x56DE;&#x7684;&#x6570;&#x636E;&#x5B57;&#x5178;&#x6570;&#x7EC4;</span>
<span class="hljs-keyword">class</span> <span class="hljs-func"><span class="hljs-keyword">func</span> <span class="hljs-title">saveStatus</span><span class="hljs-params">(array: [[String: AnyObject]])</span> </span>{
    <span class="hljs-built_in">print</span>(<span class="hljs-string">&quot;&#x4FDD;&#x5B58;&#x5230;&#x6570;&#x636E;&#x5E93; <span class="hljs-subst">\(array)</span>&quot;</span>)
}
</code></pre>
<ul>
<li>&#x5728; <code>StatusListViewModel</code> &#x4E2D;&#x589E;&#x52A0;&#x4EE3;&#x7801;&#x8C03;&#x7528;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">// 1. &#x53D6;&#x51FA;&#x7F51;&#x7EDC;&#x8FD4;&#x56DE;&#x5B57;&#x5178;&#x4E2D;&#x7684;&#x5FAE;&#x535A;&#x6570;&#x7EC4;</span>
guard <span class="hljs-keyword">let</span> array = result?[<span class="hljs-string">&quot;statuses&quot;</span>] <span class="hljs-keyword">as</span>? [[<span class="hljs-type">String</span>: <span class="hljs-type">AnyObject</span>]] <span class="hljs-keyword">else</span> {
    finished(error: <span class="hljs-type">NSError</span>(domain: <span class="hljs-string">&quot;cn.itcast.error&quot;</span>, code: -<span class="hljs-number">1001</span>, userInfo: [<span class="hljs-string">&quot;message&quot;</span>: <span class="hljs-string">&quot;&#x6570;&#x636E;&#x683C;&#x5F0F;&#x9519;&#x8BEF;&quot;</span>]))
    <span class="hljs-keyword">return</span>
}

<span class="hljs-comment">// --- &#x5C06;&#x7F51;&#x7EDC;&#x8FD4;&#x56DE;&#x7684;&#x5B57;&#x5178;&#x6570;&#x7EC4;&#x4FDD;&#x5B58;&#x81F3;&#x6570;&#x636E;&#x5E93;</span>
<span class="hljs-type">StatusDAL</span>.saveStatus(array)

<span class="hljs-comment">// 2. &#x904D;&#x5386;&#x6570;&#x7EC4;&#xFF0C;&#x5B57;&#x5178;&#x8F6C;&#x6A21;&#x578B;</span>
<span class="hljs-comment">// ...</span>
</code></pre>
<ul>
<li>&#x6D4B;&#x8BD5; SQL</li>
</ul>
<pre><code class="lang-sql"><span class="hljs-operator"><span class="hljs-keyword">INSERT</span> <span class="hljs-keyword">OR</span> <span class="hljs-keyword">REPLACE</span> <span class="hljs-keyword">INTO</span> T_Status (statusId, <span class="hljs-keyword">status</span>, userId)
<span class="hljs-keyword">VALUES</span> (<span class="hljs-number">1001</span>, <span class="hljs-string">&apos;hello world&apos;</span>, <span class="hljs-number">1</span>);</span>
</code></pre>
<ul>
<li>&#x5B9E;&#x73B0; <code>saveStatus</code> &#x51FD;&#x6570;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">/// &#x5C06;&#x7F51;&#x7EDC;&#x8FD4;&#x56DE;&#x7684;&#x6570;&#x636E;&#x5B57;&#x5178;&#x6570;&#x7EC4;&#x4FDD;&#x5B58;&#x81F3;&#x6570;&#x636E;&#x5E93;</span>
<span class="hljs-comment">///</span>
<span class="hljs-comment">/// - parameter array: &#x7F51;&#x7EDC;&#x8FD4;&#x56DE;&#x7684;&#x6570;&#x636E;&#x5B57;&#x5178;&#x6570;&#x7EC4;</span>
<span class="hljs-keyword">class</span> <span class="hljs-func"><span class="hljs-keyword">func</span> <span class="hljs-title">saveStatus</span><span class="hljs-params">(array: [[String: AnyObject]])</span> </span>{
    <span class="hljs-comment">// &#x5224;&#x65AD;&#x7528;&#x6237;&#x662F;&#x5426;&#x767B;&#x5F55;</span>
    <span class="hljs-built_in">assert</span>(<span class="hljs-type">UserAccountViewModel</span>.sharedAccountViewModel.userLogon, <span class="hljs-string">&quot;&#x5FC5;&#x987B;&#x7528;&#x6237;&#x767B;&#x5F55;&#x624D;&#x5141;&#x8BB8;&#x8C03;&#x7528;&#x6B64;&#x51FD;&#x6570;&quot;</span>)

    <span class="hljs-comment">// &#x51C6;&#x5907; SQL</span>
    <span class="hljs-keyword">let</span> sql = <span class="hljs-string">&quot;INSERT OR REPLACE INTO T_Status (statusId, status, userId) VALUES (?, ?, ?);&quot;</span>

    <span class="hljs-comment">// &#x5F53;&#x524D;&#x7528;&#x6237;&#x4EE3;&#x53F7;</span>
    <span class="hljs-keyword">let</span> userId = <span class="hljs-type">UserAccountViewModel</span>.sharedAccountViewModel.userAccount!.uid!

    <span class="hljs-comment">// &#x4FDD;&#x5B58;&#x81F3;&#x6570;&#x636E;&#x5E93;</span>
    <span class="hljs-type">SQLiteManager</span>.sharedManager.queue.inTransaction { (db, rollback) <span class="hljs-keyword">in</span>

        <span class="hljs-comment">// &#x904D;&#x5386;&#x6570;&#x7EC4;</span>
        <span class="hljs-keyword">for</span> dict <span class="hljs-keyword">in</span> array {
            <span class="hljs-comment">// 1&gt; &#x5C06;&#x5B57;&#x5178;&#x53CD;&#x5E8F;&#x5217;&#x5316;&#x6210; JSON &#x5B57;&#x7B26;&#x4E32;</span>
            <span class="hljs-keyword">let</span> json = try! <span class="hljs-type">NSJSONSerialization</span>.dataWithJSONObject(dict, options: [])
            <span class="hljs-comment">// 2&gt; &#x83B7;&#x53D6;&#x5FAE;&#x535A;&#x4EE3;&#x53F7;</span>
            <span class="hljs-keyword">let</span> statusId = dict[<span class="hljs-string">&quot;id&quot;</span>] <span class="hljs-keyword">as</span>! <span class="hljs-type">Int</span>

            <span class="hljs-comment">// 3&gt; &#x4FDD;&#x5B58;&#x81F3;&#x6570;&#x636E;&#x5E93;</span>
            <span class="hljs-keyword">if</span> !db.executeUpdate(sql, statusId, json, userId) {
                rollback.memory = <span class="hljs-built_in">true</span>
            }
        }

        <span class="hljs-built_in">print</span>(<span class="hljs-string">&quot;&#x4FDD;&#x5B58;&#x5B8C;&#x6210;&quot;</span>)
    }
}
</code></pre>
<h3 id="%E5%8A%A0%E8%BD%BD%E6%9C%AC%E5%9C%B0%E6%95%B0%E6%8D%AE">&#x52A0;&#x8F7D;&#x672C;&#x5730;&#x6570;&#x636E;</h3>
<ul>
<li>&#x52A0;&#x8F7D;&#x672C;&#x5730;&#x6570;&#x636E; &#xFF0D; &#x51C6;&#x5907;&#x51FD;&#x6570;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">/// &#x52A0;&#x8F7D;&#x672C;&#x5730;&#x7F13;&#x5B58;&#x6570;&#x636E;</span>
<span class="hljs-comment">///</span>
<span class="hljs-comment">/// - parameter since_id: &#x4E0B;&#x62C9;&#x5237;&#x65B0;</span>
<span class="hljs-comment">/// - parameter max_id:   &#x4E0A;&#x62C9;&#x5237;&#x65B0;</span>
<span class="hljs-keyword">class</span> <span class="hljs-func"><span class="hljs-keyword">func</span> <span class="hljs-title">loadCacheData</span><span class="hljs-params">(since_id: Int, max_id: Int)</span> </span>{

    <span class="hljs-comment">// &#x5224;&#x65AD;&#x7528;&#x6237;&#x662F;&#x5426;&#x767B;&#x5F55;</span>
    <span class="hljs-built_in">assert</span>(<span class="hljs-type">UserAccountViewModel</span>.sharedAccountViewModel.userLogon, <span class="hljs-string">&quot;&#x5FC5;&#x987B;&#x7528;&#x6237;&#x767B;&#x5F55;&#x624D;&#x5141;&#x8BB8;&#x8C03;&#x7528;&#x6B64;&#x51FD;&#x6570;&quot;</span>)
}
</code></pre>
<ul>
<li>&#x5728; <code>StatusListViewModel</code> &#x4E2D;&#x589E;&#x52A0;&#x4EE3;&#x7801;&#x8C03;&#x7528;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">// --- &#x52A0;&#x8F7D;&#x672C;&#x5730;&#x7F13;&#x5B58;&#x6570;&#x636E;</span>
<span class="hljs-type">StatusDAL</span>.loadCacheData(since_id, max_id: max_id)

<span class="hljs-type">NetworkTools</span>.sharedTools.loadStatus(since_id: since_id, max_id: max_id) { (result, error) -&gt; () <span class="hljs-keyword">in</span>

<span class="hljs-comment">// ...</span>
</code></pre>
<ul>
<li>&#x6D4B;&#x8BD5; SQL</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-type">SELECT</span> statusId, status, userId
<span class="hljs-type">FROM</span> <span class="hljs-type">T_Status</span>
<span class="hljs-type">WHERE</span> userId = <span class="hljs-number">5365823342</span>
    <span class="hljs-type">AND</span> statusId &lt; <span class="hljs-number">3895156706847222</span>
<span class="hljs-type">ORDER</span> <span class="hljs-type">BY</span> statusId <span class="hljs-type">DESC</span>
<span class="hljs-type">LIMIT</span> <span class="hljs-number">20</span>;
</code></pre>
<ul>
<li>&#x51FD;&#x6570;&#x5B9E;&#x73B0; - &#x51C6;&#x5907; SQL</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">// &#x51C6;&#x5907; SQL</span>
<span class="hljs-keyword">let</span> userId = <span class="hljs-type">UserAccountViewModel</span>.sharedAccountViewModel.userAccount!.uid!

<span class="hljs-keyword">var</span> sql = <span class="hljs-string">&quot;SELECT statusId, status, userId FROM T_Status \n&quot;</span> +
    <span class="hljs-string">&quot;WHERE userId = <span class="hljs-subst">\(userId)</span> \n&quot;</span>

<span class="hljs-comment">// &#x4E0B;&#x62C9;&#x5237;&#x65B0;</span>
<span class="hljs-keyword">if</span> since_id &gt; <span class="hljs-number">0</span> {
    sql += <span class="hljs-string">&quot;AND statusId &gt; <span class="hljs-subst">\(since_id)</span> \n&quot;</span>
} <span class="hljs-keyword">else</span> <span class="hljs-keyword">if</span> max_id &gt; <span class="hljs-number">0</span> {
    sql += <span class="hljs-string">&quot;AND statusId &lt; <span class="hljs-subst">\(max_id - <span class="hljs-number">1</span>)</span> \n&quot;</span>
}

sql += <span class="hljs-string">&quot;ORDER BY statusId DESC LIMIT 20;&quot;</span>

<span class="hljs-built_in">print</span>(sql)
</code></pre>
<ul>
<li>&#x6267;&#x884C; SQL &#x83B7;&#x53D6;&#x7ED3;&#x679C;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">// &#x83B7;&#x53D6;&#x67E5;&#x8BE2;&#x7ED3;&#x679C;</span>
<span class="hljs-type">SQLiteManager</span>.sharedManager.recordSet(sql) { (recordSet) -&gt; () <span class="hljs-keyword">in</span>
    guard <span class="hljs-keyword">let</span> array = recordSet <span class="hljs-keyword">else</span> {
        <span class="hljs-keyword">return</span>
    }

    <span class="hljs-comment">// &#x904D;&#x5386;&#x6570;&#x7EC4;&#xFF0C;JSON &#x53CD;&#x5E8F;&#x5217;&#x5316;</span>
    <span class="hljs-keyword">var</span> arrayM = [[<span class="hljs-type">String</span>: <span class="hljs-type">AnyObject</span>]]()
    <span class="hljs-keyword">for</span> dict <span class="hljs-keyword">in</span> array {
        <span class="hljs-keyword">let</span> json = dict[<span class="hljs-string">&quot;status&quot;</span>] <span class="hljs-keyword">as</span>! <span class="hljs-type">NSData</span>
        <span class="hljs-keyword">let</span> result = try! <span class="hljs-type">NSJSONSerialization</span>.<span class="hljs-type">JSONObjectWithData</span>(json, options: [])

        arrayM.append(result <span class="hljs-keyword">as</span>! [<span class="hljs-type">String</span>: <span class="hljs-type">AnyObject</span>])
    }

    <span class="hljs-built_in">print</span>(arrayM)
}
</code></pre>
<ul>
<li>&#x5B8C;&#x6210;&#x56DE;&#x8C03;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">/// &#x52A0;&#x8F7D;&#x672C;&#x5730;&#x7F13;&#x5B58;&#x6570;&#x636E;</span>
<span class="hljs-comment">///</span>
<span class="hljs-comment">/// - parameter since_id: &#x4E0B;&#x62C9;&#x5237;&#x65B0;</span>
<span class="hljs-comment">/// - parameter max_id:   &#x4E0A;&#x62C9;&#x5237;&#x65B0;</span>
<span class="hljs-comment">/// - parameter finished: &#x5B8C;&#x6210;&#x56DE;&#x8C03;</span>
<span class="hljs-keyword">class</span> <span class="hljs-func"><span class="hljs-keyword">func</span> <span class="hljs-title">loadCacheData</span><span class="hljs-params">(since_id: Int, max_id: Int, finished: <span class="hljs-params">(array: [[String: AnyObject]]?)</span>-&gt;<span class="hljs-params">()</span>)</span> </span>{

    <span class="hljs-comment">// &#x5224;&#x65AD;&#x7528;&#x6237;&#x662F;&#x5426;&#x767B;&#x5F55;</span>
    <span class="hljs-built_in">assert</span>(<span class="hljs-type">UserAccountViewModel</span>.sharedAccountViewModel.userLogon, <span class="hljs-string">&quot;&#x5FC5;&#x987B;&#x7528;&#x6237;&#x767B;&#x5F55;&#x624D;&#x5141;&#x8BB8;&#x8C03;&#x7528;&#x6B64;&#x51FD;&#x6570;&quot;</span>)

    <span class="hljs-comment">// &#x51C6;&#x5907; SQL</span>
    <span class="hljs-keyword">let</span> userId = <span class="hljs-type">UserAccountViewModel</span>.sharedAccountViewModel.userAccount!.uid!

    <span class="hljs-keyword">var</span> sql = <span class="hljs-string">&quot;SELECT status FROM T_Status \n&quot;</span> +
        <span class="hljs-string">&quot;WHERE userId = <span class="hljs-subst">\(userId)</span> \n&quot;</span>

    <span class="hljs-comment">// &#x4E0B;&#x62C9;&#x5237;&#x65B0;</span>
    <span class="hljs-keyword">if</span> since_id &gt; <span class="hljs-number">0</span> {
        sql += <span class="hljs-string">&quot;AND statusId &gt; <span class="hljs-subst">\(since_id)</span> \n&quot;</span>
    } <span class="hljs-keyword">else</span> <span class="hljs-keyword">if</span> max_id &gt; <span class="hljs-number">0</span> {
        sql += <span class="hljs-string">&quot;AND statusId &lt; <span class="hljs-subst">\(max_id - <span class="hljs-number">1</span>)</span> \n&quot;</span>
    }

    sql += <span class="hljs-string">&quot;ORDER BY statusId DESC LIMIT 20;&quot;</span>

    <span class="hljs-comment">// &#x83B7;&#x53D6;&#x67E5;&#x8BE2;&#x7ED3;&#x679C;</span>
    <span class="hljs-type">SQLiteManager</span>.sharedManager.recordSet(sql) { (recordSet) -&gt; () <span class="hljs-keyword">in</span>
        guard <span class="hljs-keyword">let</span> array = recordSet <span class="hljs-keyword">else</span> {
            finished(array: <span class="hljs-built_in">nil</span>)
            <span class="hljs-keyword">return</span>
        }

        <span class="hljs-comment">// &#x904D;&#x5386;&#x6570;&#x7EC4;&#xFF0C;JSON &#x53CD;&#x5E8F;&#x5217;&#x5316;</span>
        <span class="hljs-keyword">var</span> arrayM = [[<span class="hljs-type">String</span>: <span class="hljs-type">AnyObject</span>]]()
        <span class="hljs-keyword">for</span> dict <span class="hljs-keyword">in</span> array {
            <span class="hljs-keyword">let</span> json = dict[<span class="hljs-string">&quot;status&quot;</span>] <span class="hljs-keyword">as</span>! <span class="hljs-type">NSData</span>
            <span class="hljs-keyword">let</span> result = try! <span class="hljs-type">NSJSONSerialization</span>.<span class="hljs-type">JSONObjectWithData</span>(json, options: [])

            arrayM.append(result <span class="hljs-keyword">as</span>! [<span class="hljs-type">String</span>: <span class="hljs-type">AnyObject</span>])
        }

        finished(array: arrayM)
    }
}
</code></pre>
<ul>
<li>&#x4FEE;&#x6539; <code>StatusListViewModel</code> &#x4E2D;&#x7684;&#x6D4B;&#x8BD5;&#x4EE3;&#x7801;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">// --- &#x52A0;&#x8F7D;&#x672C;&#x5730;&#x7F13;&#x5B58;&#x6570;&#x636E;</span>
<span class="hljs-type">StatusDAL</span>.loadCacheData(since_id, max_id: max_id) { array <span class="hljs-keyword">in</span>
    <span class="hljs-keyword">if</span> array?.<span class="hljs-built_in">count</span> &gt; <span class="hljs-number">0</span> {
        <span class="hljs-built_in">print</span>(<span class="hljs-string">&quot;&#x6709;&#x7F13;&#x5B58;&#x6570;&#x636E;&quot;</span>)
    } <span class="hljs-keyword">else</span> {
        <span class="hljs-built_in">print</span>(<span class="hljs-string">&quot;&#x6CA1;&#x6709;&#x7F13;&#x5B58;&#x6570;&#x636E;&quot;</span>)
    }
}
</code></pre>
<h3 id="%E5%AE%9E%E7%8E%B0-loadstatus-%E6%96%B9%E6%B3%95">&#x5B9E;&#x73B0; <code>loadStatus</code> &#x65B9;&#x6CD5;</h3>
<ul>
<li>&#x5B9E;&#x73B0; <code>StatusDAL</code> &#x4E2D;&#x7684;&#x52A0;&#x8F7D;&#x5FAE;&#x535A;&#x51FD;&#x6570;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-comment">/// &#x52A0;&#x8F7D;&#x5FAE;&#x535A;&#x6570;&#x636E;</span>
<span class="hljs-comment">///</span>
<span class="hljs-comment">/// - parameter since_id: &#x4E0B;&#x62C9;&#x5237;&#x65B0;</span>
<span class="hljs-comment">/// - parameter max_id:   &#x4E0A;&#x62C9;&#x5237;&#x65B0;</span>
<span class="hljs-comment">/// - parameter finished: &#x5B8C;&#x6210;&#x56DE;&#x8C03;</span>
<span class="hljs-keyword">class</span> <span class="hljs-func"><span class="hljs-keyword">func</span> <span class="hljs-title">loadStatus</span><span class="hljs-params">(since_id: Int, max_id: Int, finished: <span class="hljs-params">(array: [[String: AnyObject]]?, error: NSError?)</span>-&gt;<span class="hljs-params">()</span>)</span> </span>{

    <span class="hljs-comment">// 1. &#x68C0;&#x67E5;&#x672C;&#x5730;&#x662F;&#x5426;&#x5B58;&#x5728;&#x7F13;&#x5B58;&#x6570;&#x636E;</span>
    loadCacheData(since_id, max_id: max_id) { array <span class="hljs-keyword">in</span>

        <span class="hljs-keyword">if</span> array?.<span class="hljs-built_in">count</span> &gt; <span class="hljs-number">0</span> {
            <span class="hljs-comment">// 2. &#x5982;&#x679C;&#x6709;&#x8FD4;&#x56DE;&#x672C;&#x5730;&#x7F13;&#x5B58;&#x6570;&#x636E;</span>
            finished(array: array, error: <span class="hljs-built_in">nil</span>)
            <span class="hljs-keyword">return</span>
        }

        <span class="hljs-comment">// 3. &#x5982;&#x679C;&#x6CA1;&#x6709;&#x53D1;&#x8D77;&#x7F51;&#x7EDC;&#x8BF7;&#x6C42;</span>
        <span class="hljs-type">NetworkTools</span>.sharedTools.loadStatus(since_id: since_id, max_id: max_id) { (result, error) -&gt; () <span class="hljs-keyword">in</span>
            <span class="hljs-keyword">if</span> error != <span class="hljs-built_in">nil</span> {
                finished(array: <span class="hljs-built_in">nil</span>, error: error)
                <span class="hljs-keyword">return</span>
            }

            <span class="hljs-comment">// 4. &#x52A0;&#x8F7D;&#x5B8C;&#x6210;&#x4FDD;&#x5B58;&#x81F3;&#x6570;&#x636E;&#x5E93;</span>
            <span class="hljs-comment">// 1&gt; &#x53D6;&#x51FA;&#x7F51;&#x7EDC;&#x8FD4;&#x56DE;&#x5B57;&#x5178;&#x4E2D;&#x7684;&#x5FAE;&#x535A;&#x6570;&#x7EC4;</span>
            guard <span class="hljs-keyword">let</span> array = result?[<span class="hljs-string">&quot;statuses&quot;</span>] <span class="hljs-keyword">as</span>? [[<span class="hljs-type">String</span>: <span class="hljs-type">AnyObject</span>]] <span class="hljs-keyword">else</span> {
                finished(array: <span class="hljs-built_in">nil</span>, error: <span class="hljs-type">NSError</span>(domain: <span class="hljs-string">&quot;cn.itcast.error&quot;</span>, code: -<span class="hljs-number">1001</span>, userInfo: [<span class="hljs-string">&quot;message&quot;</span>: <span class="hljs-string">&quot;&#x6570;&#x636E;&#x683C;&#x5F0F;&#x9519;&#x8BEF;&quot;</span>]))
                <span class="hljs-keyword">return</span>
            }

            <span class="hljs-comment">// 2&gt; &#x5C06;&#x7F51;&#x7EDC;&#x8FD4;&#x56DE;&#x7684;&#x5B57;&#x5178;&#x6570;&#x7EC4;&#x4FDD;&#x5B58;&#x81F3;&#x6570;&#x636E;&#x5E93;</span>
            <span class="hljs-type">StatusDAL</span>.saveStatus(array)

            <span class="hljs-comment">// 3&gt; &#x5B8C;&#x6210;&#x56DE;&#x8C03;</span>
            finished(array: array, error: <span class="hljs-built_in">nil</span>)
        }
    }
}
</code></pre>
<ul>
<li>&#x4FEE;&#x6539; <code>StatusListViewModel</code> &#x6A21;&#x578B;&#x4E2D;&#x7684; <code>loadStatus</code> &#x51FD;&#x6570;</li>
</ul>
<pre><code class="lang-swift"><span class="hljs-type">StatusDAL</span>.loadStatus(since_id, max_id: max_id) { (array, error) -&gt; () <span class="hljs-keyword">in</span>

    <span class="hljs-keyword">if</span> error != <span class="hljs-built_in">nil</span> {
        finished(error: error)
        <span class="hljs-keyword">return</span>
    }

    <span class="hljs-comment">// 2. &#x904D;&#x5386;&#x6570;&#x7EC4;&#xFF0C;&#x5B57;&#x5178;&#x8F6C;&#x6A21;&#x578B;</span>
    <span class="hljs-comment">// 1&gt; &#x521B;&#x5EFA;&#x4E00;&#x4E2A;&#x53EF;&#x53D8;&#x7684;&#x5FAE;&#x535A;&#x6A21;&#x578B;&#x6570;&#x7EC4;</span>
    <span class="hljs-keyword">var</span> arrayM = [<span class="hljs-type">StatusViewModel</span>]()

    <span class="hljs-comment">// 2&gt; &#x904D;&#x5386;</span>
    <span class="hljs-keyword">for</span> dict <span class="hljs-keyword">in</span> array! {
        arrayM.append(<span class="hljs-type">StatusViewModel</span>(status: <span class="hljs-type">Status</span>(dict: dict)))
    }

    <span class="hljs-built_in">print</span>(<span class="hljs-string">&quot;&#x52A0;&#x8F7D;&#x4E86; <span class="hljs-subst">\(arrayM.<span class="hljs-built_in">count</span>)</span> &#x6761;&#x6570;&#x636E;&quot;</span>)

    <span class="hljs-comment">// &#x53EA;&#x6709;&#x4E0B;&#x62C9;&#x5237;&#x65B0;&#x624D;&#x8BB0;&#x5F55;&#x5237;&#x65B0;&#x884C;&#x6570;</span>
    <span class="hljs-keyword">self</span>.pulldownCount = since_id &gt; <span class="hljs-number">0</span> ? arrayM.<span class="hljs-built_in">count</span> : <span class="hljs-built_in">nil</span>

    <span class="hljs-comment">// 3&gt; &#x62FC;&#x63A5;&#x6570;&#x7EC4;</span>
    <span class="hljs-comment">// &#x5982;&#x679C;&#x662F;&#x4E0A;&#x62C9;&#x5237;&#x65B0;&#xFF0C;&#x5C06;&#x6570;&#x7EC4;&#x8FFD;&#x52A0;&#x5230;&#x672B;&#x5C3E;</span>
    <span class="hljs-keyword">if</span> max_id &gt; <span class="hljs-number">0</span> {
        <span class="hljs-keyword">self</span>.statuses += arrayM
    } <span class="hljs-keyword">else</span> {
        <span class="hljs-comment">// &#x4E0B;&#x62C9;&#x5237;&#x65B0;&#x6216;&#x8005;&#x521D;&#x59CB;&#x5237;&#x65B0;&#xFF0C;&#x65B0;&#x7684;&#x5FAE;&#x535A;&#x8FFD;&#x52A0;&#x5230;&#x6570;&#x7EC4;&#x7684;&#x524D;&#x9762;</span>
        <span class="hljs-keyword">self</span>.statuses = arrayM + <span class="hljs-keyword">self</span>.statuses
    }

    <span class="hljs-comment">// 4&gt; &#x7F13;&#x5B58;&#x7F51;&#x8DEF;&#x56FE;&#x7247;</span>
    <span class="hljs-keyword">self</span>.cacheWebImage(arrayM, finished: finished)
}
</code></pre>
<blockquote>
<p>&#x8FD0;&#x884C;&#x6D4B;&#x8BD5;</p>
</blockquote>

                    
                    </section>
                
                
                </div>
            </div>
        </div>

        
        <a href="../sqlite/data model.html" class="navigation navigation-prev " aria-label="Previous page: 数据模型设计"><i class="fa fa-angle-left"></i></a>
        
        
        <a href="../sqlite/clean cache.html" class="navigation navigation-next " aria-label="Next page: 清理数据缓存"><i class="fa fa-angle-right"></i></a>
        
    </div>
</div>

        
<script src="../gitbook/app.js"></script>

<script>
require(["gitbook"], function(gitbook) {
    var config = {"fontSettings":{"theme":null,"family":"sans","size":2}};
    gitbook.start(config);
});
</script>

        
    </body>
    
</html>
